[NHibernate and ASP.NET MVC] How can I implement a robust session-per-request pattern in my project,

Posted by Guillaume Gervais on Stack Overflow See other posts from Stack Overflow or by Guillaume Gervais
Published on 2010-01-12T01:51:27Z Indexed on 2010/05/16 20:10 UTC
Read the original article Hit count: 216

I'm currently building an ASP.NET MVC project, with NHibernate as its persistance layer.

For now, some functionnalities have been implemented, but only use local NHibernate sessions: each method that accessed the database (read or write) needs to instanciate its own NHibernate session, with the "using()" directive.

The problem is that I want to leverage NHibernate's Lazy-Loading capabilities to improve the performance of my project.

This implies an open NHibernate session per request until the view is rendered. Furthermore, simultaneous request must be supported (multiple Sessions at the same time).

How can I achieve that as cleanly as possible?

I searched the Web a little bit and learned about the session-per-request pattern. Most of the implementations I saw used some sort of Http* (HttpContext, etc.) object to store the session. Also, using the Application_BeginRequest/Application_EndRequest functions is complicated, since they get fired for each HTTP request (aspx files, css files, js files, etc.), when I only want to instanciate a session once per request.

The concern that I have is that I don't want my views or controllers to have access to NHibernate sessions (or, more generally, NHibernate namespaces and code). That means that I do not want to handle sessions at the controller level nor the view one.

I have a few options in mind. Which one seems the best ?

  • Use interceptors (like in GRAILS) that get triggered before and after the controller action. These would open and close sessions/transactions. Is it possible in the ASP.NET MVC world?
  • Use the CurrentSessionContext Singleton provided by NHibernate in a Web context. Using this page as an example, I think this is quite promising, but that still requires filters at the controller level.
  • Use the HttpContext.Current.Items to store the request session. This, coupled with a few lines of code in Global.asax.cs, can easily provide me with a session on the request level. However, it means that dependencies will be injected between NHibernate and my views (HttpContext).

Thank you very much!

© Stack Overflow or respective owner

Related posts about asp.net-mvc

Related posts about nhibernate